Spreadsheet Twin Cities Project
(25 points)

1. Locate the following information, use screen shot to verify findings and use to complete the project requirements. Insert screen shots and findings into one Spreadsheet.
    
2. Travel Information - family of four (ages: 42, 39, 15, and 12)
   • Use an on-line map site to determine mileage from Sturgis, SD to your destination. Calculate driving costs if your vehicle gets 27 mpg and gas costs $3.32 per gallon. Be sure to compute costs round-trip.
      
3. Budget
   • You will draw for amount. Use if function to determine if you are under budget.
   • If you are over budget, how could you reduce costs for this trip?

4. Lodging Information - family of four (ages: 42, 39, 15, and 12)
   • Find lodging for two nights in the Twin Cities area. Use screen shot for name, picture, cost, and description of room.
      
5. Food Information (ages: 42, 39, 15, and 12)
   • Find cost of food, it must include breakfast, lunch, and dinner for the duration of your trip.
      
6. Entertainment Information (ages: 42, 39, 15, and 12)
   • Locate two attractions / activities that you will visit in the Twin Cities area.
      
7. Spreadsheet
   • All screen shots (directions, lodging, 3 food, and 2 entertainment) and calculations must be completed in spreadsheet.
   • Create an spreadsheet for car travel, lodging, food, and entertainment. Use formulas to calculate subtotals and totals.
   • Create a pie chart for total travel car, lodging, food, and entertainment.